From bc841b2fcf553de26875ede516684a402aa606eb Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Mon, 19 Aug 2024 18:57:43 -0500
Subject: [PATCH] Report warning when there are no results

---
 src/pgwui_sql/exceptions.py | 13 +++++++++++++
 src/pgwui_sql/views/sql.py  |  4 ++++
 2 files changed, 17 insertions(+)

diff --git a/src/pgwui_sql/exceptions.py b/src/pgwui_sql/exceptions.py
index b6391ae..1b0377a 100644
--- a/src/pgwui_sql/exceptions.py
+++ b/src/pgwui_sql/exceptions.py
@@ -55,6 +55,7 @@ class SQLError(core_ex.UploadError):
     def __init__(self, e, lineno, descr='', detail=''):
         super().__init__(e, lineno, descr=descr, detail=detail)
 
+
 class ExecutionError(SQLError):
     '''
     Error raised when processing SQL
@@ -66,3 +67,15 @@ class ExecutionError(SQLError):
     def __init__(self, e, lineno, descr='', detail=''):
         super().__init__(f'{e} when executing SQL',
                          lineno, descr=descr, detail=detail)
+
+
+class NoStatementsError(SQLError):
+    '''
+    Error raised when execution "succeeded" but there are no results
+
+    descr  More description of the error
+    detail Extra HTML describing the error
+    '''
+    def __init__(self, descr='', detail=''):
+        super().__init__('Warning when executing SQL',
+                         '', descr=descr, detail=detail)
diff --git a/src/pgwui_sql/views/sql.py b/src/pgwui_sql/views/sql.py
index dc75dfc..0494469 100644
--- a/src/pgwui_sql/views/sql.py
+++ b/src/pgwui_sql/views/sql.py
@@ -194,6 +194,10 @@ class SQLHandler(pgwui_core.core.SessionDBHandler):
         '''
         cur = self.cur
         self.execute(cur, self.uf['sql'])
+        if cur.statusmessage is None:
+            raise sql_ex.NoStatementsError(
+                descr=('There seem to be no SQL statements, or at least no'
+                       ' results'))
 
         sql_results = self.sql_results
         nextset = True
-- 
2.34.1